Portal Login Retreval

[kolucoms6]

My technical guy provided with me Root Password but Didn't provide me with the Portal Admin password and gave me one Local admin but with Restriction.

How to Retrieve ADMIN password ?

[kolucoms6]

Anyway to do it ?

[williamconley]

honestly, password crack requests are frowned upon. especially posting them. i could give you offline advice if i could verify your ownership of the box (although having the root password is compelling, it's not final).

[kolucoms6]

How to open mysql database from webmin and view table data and content ?

[williamconley]

um .. click on mysql in webmin under servers, then click on the asterisk database ...
then choose the appropriate table and click on "view data"

[kolucoms6]

When i click on Mysql, it says :

SQL show index from `recording_log` failed : Table './asterisk/recording_log' is marked as crashed and should be repaired

[kolucoms6]

If I run this command, it will resolve all database problems ?

mysqlcheck --auto-repair asterisk -p

[williamconley]

it is likely, and it will not hurt.

make sure noone is using the system when you do it.

you may need to run the command more than once.

you may need to add the actual table to be repaired as well. (this one is for the entire database)

[kolucoms6]

So, command would be

mysqlcheck --auto-repair asterisk recording_log -p

Correct ?

[williamconley]

mysqlcheck --auto-repair asterisk recording_log -p

if that (recording_log) is the name of your defective table, yes

[kolucoms6]

vicidialnow*CLI>
You have new mail in /var/spool/mail/root
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
You have new mail in /var/spool/mail/root
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
[root@vicidialnow ~]#

What password do I need to enter over here ? Root password ?

[williamconley]

do you know the root mysql password for your installation? this is where you would put it. Check your documentation. Especially if you don't know what it is, it is likely to still be the password generated or installed by the system.

[kolucoms6]

I can change Mysql password from webmin but is there any default ?

[williamconley]

if you can change the ROOT mysql password, do so. it is not to be used to perform database tasks, only for administrator "master access".

never use root mysql to perform any tasks (except for this) and never give your root mysql password to anyone you do not trust.

all other mysql accounts/users should be limited in what they can do and on what database, generally to a single database and only used for the program accessing that data.

when and where to set each account and password is listed in the scratch install for vicidial, you can change the password and even the account name, but if you do so you must be sure it is changed in both mysql AND in the vicidial configuration files.

[daaliya]

Can i Run a VOIP router with a wireless router from same computer?
I have a Lingo Router, and i wanna hook my Playstation 3 via Wi-Fi. So i bought a Wireless G router, however it doesnt support VOIP. So i was wondering can i hook both of them up some how?? or are there special wireless routers that supporot VOIP?